r = open('../99 文件目录/行政区域原文件.txt', 'r', encoding="utf-8")
w = open('../99 文件目录/行政区域sql文件.txt', 'w', encoding="utf-8")

while True:
    line = r.readline().strip('\n')
    if line:
        w.write("INSERT INTO [dbo].[area_mst] VALUES('%s',N'%s');\n" % tuple(line.split(',')))
    else:
        break

r.close()
w.close()
